﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace QuanLyThongTinNhanKhau.model.DAO
{
    class TKTATSDAO
    {
        SQLServiceDAO service = new SQLServiceDAO();

        internal System.Data.DataTable btnThongKe(string fromDate, string toDate)
        {
            String sql = "select MaTienAnTienSu, t.MaNhanKhau, HoTen, NgaySinh, NoiThuongTru, NgayViPham, NoiDung, HinhThucXuLy from NHANKHAU n join TIENANTIENSU t on n.MaNhanKhau = t.MaNhanKhau where NgayViPham >= '" + fromDate + "' and NgayViPham <= '" + toDate + "' and t.TinhTrang = 'Enable'";
            return service.getDataTable(sql);
        }
    }
}
